Release 10.1A: OpenEdge Data Management:
Database Administration

Dumping an SQL view file’s contents with a Data tool

The process for dumping the contents of an SQL file is similar to that for dumping a table’s contents or sequence’s values.

To dump an SQL view file’s contents:

Access the appropriate Data tool (the Data Administration tool if you are using a graphical interface or the Data Dictionary if you are using a character interface).
Make sure you are using the database (the source) where you want to dump the table data.
Choose Admin Dump Data and Definitions Views. The Data tool prompts you for the file, then for the file that you want to write the user file contents to. The default filename is _view.d.
Specify the filename or accept the default. After dumping the view file contents to the specified file, the Data tool displays a status message and prompts you to continue.
Choose OK to return to the Data Administration or Data Dictionary main window.
Note: For a complete description of dumping and loading SQL content, see Chapter 24, " SQL Utilities."